﻿CREATE TABLE [dbo].[HaltInfo] (
    [Id]          INT           IDENTITY (1, 1) NOT NULL,
    [HaltDate]    DATETIME      NULL,
    [DeptId]      NVARCHAR (50) NULL,
    [DeptName]    NVARCHAR (50) NULL,
    [DoctorId]    NVARCHAR (50) NULL,
    [DoctorName]  NVARCHAR (50) NULL,
    [RegType]     NVARCHAR (50) NULL,
    [TimeSlice]   NVARCHAR (50) NULL,
    [StartTime]   NVARCHAR (50) NULL,
    [EndTime]     NVARCHAR (50) NULL,
    [OPTime]      DATETIME      NULL,
    [CreateTime]  DATETIME      NULL,
    [IsProcessed] INT           CONSTRAINT [DF__HaltInfo__IsProc__0BC6C43E] DEFAULT ((0)) NULL,
    [ProcessTime] DATETIME      NULL,
    CONSTRAINT [PK__HaltInfo__3214EC0709DE7BCC] PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'停诊日期', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'HaltInfo', @level2type = N'COLUMN', @level2name = N'HaltDate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'科室编号', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'HaltInfo', @level2type = N'COLUMN', @level2name = N'DeptId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'科室名称', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'HaltInfo', @level2type = N'COLUMN', @level2name = N'DeptName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'医生ID', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'HaltInfo', @level2type = N'COLUMN', @level2name = N'DoctorId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'医生姓名', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'HaltInfo', @level2type = N'COLUMN', @level2name = N'DoctorName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'号类别', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'HaltInfo', @level2type = N'COLUMN', @level2name = N'RegType';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'时间段', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'HaltInfo', @level2type = N'COLUMN', @level2name = N'TimeSlice';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'停诊开始时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'HaltInfo', @level2type = N'COLUMN', @level2name = N'StartTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'结束时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'HaltInfo', @level2type = N'COLUMN', @level2name = N'EndTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'停诊操作时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'HaltInfo', @level2type = N'COLUMN', @level2name = N'OPTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'创建时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'HaltInfo', @level2type = N'COLUMN', @level2name = N'CreateTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'是否已处理，1：已处理，0：未处理', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'HaltInfo', @level2type = N'COLUMN', @level2name = N'IsProcessed';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'处理时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'HaltInfo', @level2type = N'COLUMN', @level2name = N'ProcessTime';

